Advanced Excel Essentials by Jordan Goldmeier

Author:Jordan Goldmeier
Language: eng
Format: epub, pdf
Publisher: Apress, Berkeley, CA

Figure 5-27.The result of using the Array formula to pull back data

4.Once you have the first row, you can simply drag down to fill the entire region, as shown in Figure 5-28.

Figure 5-28.Dragging the array formula down the entire table

5.You’ll also need to do the same for the Year column. You need to pull the corresponding cell for the given year from the backend data. Here, you’ll use the formula INDEX(TornadoData.Year, A4) (see Figure 5-29) and then drag down.

Figure 5-29.Use INDEX to retrieve the total tornados for a given year

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.